﻿CREATE TABLE [dbo].[Assets_Names] (
    [Id]         INT              IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [GId]        UNIQUEIDENTIFIER CONSTRAINT [DF_Assets_Names_GId] DEFAULT (newid()) ROWGUIDCOL NULL,
    [CategoryId] INT              NULL,
    [Title]      NVARCHAR (50)    NULL,
    [Sort]       INT              CONSTRAINT [DF_Assets_Names_Sort] DEFAULT ((0)) NULL,
    [typeid]     INT              CONSTRAINT [DF_Assets_Names_typeid] DEFAULT ((0)) NULL,
    CONSTRAINT [PK_Assets_Names] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'GUID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Assets_Names', @level2type = N'COLUMN', @level2name = N'GId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'类别ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Assets_Names', @level2type = N'COLUMN', @level2name = N'CategoryId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'资产名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Assets_Names', @level2type = N'COLUMN', @level2name = N'Title';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'排序', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Assets_Names', @level2type = N'COLUMN', @level2name = N'Sort';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'管理类别1：固定公用类2：分配使用类3：耗材低值类', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Assets_Names', @level2type = N'COLUMN', @level2name = N'typeid';

